UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ugs6d7K2m23DflgKzubImd/Z9GJs9Zu4e1IfBGPx4o='
WHERE
key_id = 'f94149b13e0fdd6af82e3a1b41eddf5bd4ef8760840ef300acac846a90e1ba85'
AND (
token = '/ugs6d7K2m23DflgKzubImd/Z9GJs9Zu4e1IfBGPx4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)