UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '57swdMWz8umOv/85L8sSiPqyVcey2Y7jwQGKWlYaJZw='
WHERE
key_id = '12f4119d737b55f6a06c28c4e2d8900678b2f5ddcdefde75371fc66de89ebe6e'
AND (
token = '57swdMWz8umOv/85L8sSiPqyVcey2Y7jwQGKWlYaJZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)