UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1naE8JzdkeMh5UZWTsdaz4n5+8elVsGJ50U6M24Qu7Y='
WHERE
key_id = '4d8b0a84445df7812b913480a712e4c1ce0ee8f30baa7aaf28aae8c39c109388'
AND (
token = '1naE8JzdkeMh5UZWTsdaz4n5+8elVsGJ50U6M24Qu7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)