UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1p9MqK84vtYcSnFj3Gnv0tutCvwZBeGL4SqIatKKjlU='
WHERE
key_id = 'e31fc49e1695ad5196ef4b319198bfd119ef3d73874fdcad00b6a54eaa61a0e6'
AND (
token = '1p9MqK84vtYcSnFj3Gnv0tutCvwZBeGL4SqIatKKjlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)