UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CccD2lZCFfiQOip37pp5Xr2dsLLaNJR4nwV56+ZBz7Y='
WHERE
key_id = 'e0402a2d24babcc92246602da335347ed1edd6543505d51ac0a6a2df70d1149e'
AND (
token = 'CccD2lZCFfiQOip37pp5Xr2dsLLaNJR4nwV56+ZBz7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)