UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CJxofM01E5bposS9Zx8Yv99Ul9SFpGItLm5CyIWAzXo='
WHERE
key_id = 'a1b363c7d1344e8c21e72ef777331c3ff060286da92aa47699ad400218fe0c8c'
AND (
token = 'CJxofM01E5bposS9Zx8Yv99Ul9SFpGItLm5CyIWAzXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)