UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vB7f1oTMepZde+b04SkYPB/olePBvhtLh8amltp7LzE='
WHERE
key_id = 'c313ea772565d4826cc8623029c3d595c230e495c91f317b6455af667af694fb'
AND (
token = 'vB7f1oTMepZde+b04SkYPB/olePBvhtLh8amltp7LzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)