UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kXsnTt4WKrbbhfhE1boKI7Ezu8hyGbN5eYMEt7It72c='
WHERE
key_id = 'c91b9864aee3501a591b76ed24481c400fc4a528dbf0858fe743efc4cc5df351'
AND (
token = 'kXsnTt4WKrbbhfhE1boKI7Ezu8hyGbN5eYMEt7It72c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)