UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QmgYrp2fWKJkHE8yoMkFuqd9v5Gu/2nY64TzVh6zMEU='
WHERE
key_id = 'd14ff4717cb4ef06de96cf582fbb75c7f640a8eb4d202fa0510446054882a383'
AND (
token = 'QmgYrp2fWKJkHE8yoMkFuqd9v5Gu/2nY64TzVh6zMEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)