UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p40T88nIoEzNbK3Xs+99KOLHE7UdvAM+ADPgR9NAfQ0='
WHERE
key_id = 'abdf7d1a840e15787bd8eeb441c12f221f66da58dbd9c6715a3eddc871c24bd0'
AND (
token = 'p40T88nIoEzNbK3Xs+99KOLHE7UdvAM+ADPgR9NAfQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)