UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aPHHJfQ1aw5VI3Q/krIfzRA4NhVfHZGaFNieNdy6iro='
WHERE
key_id = 'bdb8b89d5364bae03a3b9fc4d77e89003a7f1cd702d01d54a9ffdd7de71a6637'
AND (
token = 'aPHHJfQ1aw5VI3Q/krIfzRA4NhVfHZGaFNieNdy6iro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)