UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HwBx4hi8eo3pGE12v4oZyy7rOApsBfGmlnA63tF6Z1Q='
WHERE
key_id = '5304795b43bb09ee23196854f0f064d3a49be65bbf91bf57785b50ebd83e4bd2'
AND (
token = 'HwBx4hi8eo3pGE12v4oZyy7rOApsBfGmlnA63tF6Z1Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)