UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prZUl8vZqMTMsTIABv5NiIDS6d0BBMK/A94FFMKQqRM='
WHERE
key_id = 'd3c727c9c31f2b96a265af5056ab42a2e96c1fadc9c1e38b9739b800a5bb7687'
AND (
token = 'prZUl8vZqMTMsTIABv5NiIDS6d0BBMK/A94FFMKQqRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)