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