UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CfQ68JueThnKOnr2S5BLcQyHSOyIwwkGctj9Spqp89k='
WHERE
key_id = '427c345dc4ea46b8991048ff7683313f91a953f486fc3dd83e18d4000ca5ab15'
AND (
token = 'CfQ68JueThnKOnr2S5BLcQyHSOyIwwkGctj9Spqp89k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)