UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mR1DnmgYlhrJlUZVjk1gKY5Oob3r9vvKs5eybs5hCsM='
WHERE
key_id = 'a47cc3a120a86bfc6466fb14726a0f139bf77ed707b78ef784cee3b24cbe2b00'
AND (
token = 'mR1DnmgYlhrJlUZVjk1gKY5Oob3r9vvKs5eybs5hCsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)