UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u4OM8xbvcSUKK1UiuENlnhsIWYIYsRpoR2U/P6qTJnw='
WHERE
key_id = 'f6dd0b74fa3a801c4e884fdc96ca3cde63d44349d5d69f63c06a5be27de84bb6'
AND (
token = 'u4OM8xbvcSUKK1UiuENlnhsIWYIYsRpoR2U/P6qTJnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)