UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tzWjTAKq51Kz2NaJR7oSmDiA04EKTYpNEb5uMd9QUk='
WHERE
key_id = '42914794cc9143747c8c276accb6a290e9cb40286473323e849701e63902af63'
AND (
token = '8tzWjTAKq51Kz2NaJR7oSmDiA04EKTYpNEb5uMd9QUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)