UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YCsPwn0ScGm1bcLE+rzSoRv/bVIthZRnvW/yH5sXRM='
WHERE
key_id = 'f424ff8c45a4fe0c50edd2463e3478ca422719994ec4c80684988370a22a3c27'
AND (
token = '8YCsPwn0ScGm1bcLE+rzSoRv/bVIthZRnvW/yH5sXRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)