UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OtfzO6h0Q8mG9DvBEB0NyMPIwwwlmKoprzeFJfVUwX0='
WHERE
key_id = '540841f503d217d9a643bceeee5d4ae09bf3e5c9573333b38fb4144287b8b3ac'
AND (
token = 'OtfzO6h0Q8mG9DvBEB0NyMPIwwwlmKoprzeFJfVUwX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)