UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qPdw2SdFYoqZhHqxNbZemwSZqinOEOAN5b9enCmjT0='
WHERE
key_id = '4ca20e7a2541b6fdbdb285aa836267d1781c476e71ed638b3bc82646aff8d813'
AND (
token = '4qPdw2SdFYoqZhHqxNbZemwSZqinOEOAN5b9enCmjT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)