UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmlvY2kD+lSv1TjUNcjH21FGbH43VdnBS5I+c4MxQxU='
WHERE
key_id = 'cbf945225a77f18dad64bec05809d32e0df48d087ab43f1ae47cf73036ad043a'
AND (
token = 'XmlvY2kD+lSv1TjUNcjH21FGbH43VdnBS5I+c4MxQxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)