UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qdtBjN4fKTDpmM770AN6LCv+4xiPalFrF82CHzJqxHg='
WHERE
key_id = 'a6439fa58d7652fee714fff6ec0ff70f87d2b3b7144bcfd87d79f16400e89ff5'
AND (
token = 'qdtBjN4fKTDpmM770AN6LCv+4xiPalFrF82CHzJqxHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)