UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWpeV6ZwCA2hnBgW13kyjlwmsdCqWa5G8Fv7yizwRLI='
WHERE
key_id = '9c7c0220ba4882a337d28a179ff947b0bfae7c79eba3d8205305df8518aeb474'
AND (
token = 'nWpeV6ZwCA2hnBgW13kyjlwmsdCqWa5G8Fv7yizwRLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)