UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CzHvpfTCeNoMSTUxq2QkDo2LLq0AHG8tU/3Zdjm+ACs='
WHERE
key_id = 'e24ae055a841b2670f14b493058fc4edb265626631f8f6d09afb885bd4e64d78'
AND (
token = 'CzHvpfTCeNoMSTUxq2QkDo2LLq0AHG8tU/3Zdjm+ACs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)