UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdscY1LIG4g0iv2vTDXm4sprdGE2aoy4JTSaGunA4Jo='
WHERE
key_id = '970ce6a189c936fc543f0de7218b209c53a3a29e4458459f687b77ba9ba86411'
AND (
token = 'mdscY1LIG4g0iv2vTDXm4sprdGE2aoy4JTSaGunA4Jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)