UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2XhqbNbv/mVAaZCPHFlRIrfCj3PwbXE74rQzz4WQJgs='
WHERE
key_id = '29f21c1aca03447b4d0cfbddea9d3fc3c89f4a86ad179719fdf3c97c598ce3e6'
AND (
token = '2XhqbNbv/mVAaZCPHFlRIrfCj3PwbXE74rQzz4WQJgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)